/*
	Created: Jonathan Turner
		On : 10/18/2013
Description: Update a user's password salt.
	Updates:
*/
ALTER PROCEDURE dbo.UpdateSalt
  @UserName VARCHAR(100)
, @Salt VARCHAR(100)
AS 
  UPDATE  mem
  SET     PasswordSalt = @Salt
  FROM    dbo.aspnet_Membership mem
  INNER JOIN dbo.aspnet_Users AS usr ON mem.UserId = usr.UserId
  WHERE   usr.LoweredUserName = @UserName

 GO
